package com.scau.ums.util.dao;

/**
 * @author xfy
 * @version 1.0
 * @date 2019/8/18 12:42
 */
public class LostInfoSql {
    public String getCheckedLostInfoSumByKeyword(String keyword){
        return "SELECT COUNT(*) FROM lostAndFoundInfo where state = '审核通过' and concat(IFNULL(telephone,''),IFNULL(itemName,''),IFNULL(itemDesc,'')) like '%"
                + keyword + "%'; ";
    }
    public String getCheckedLostInfoPageByKeyword(int start,int number,String keyword){
        return "select * from lostAndFoundInfo where state = '审核通过' and concat(IFNULL(telephone,''),IFNULL(itemName,''),IFNULL(itemDesc,'')) like '%"
                + keyword + "%' limit " + start + "," + number + ";";
    }

}
